Use DistributionDB  --Run this on BBA-Orl-SQLPOS

declare @distribution_Agent_name sysname
set @distribution_Agent_name ='SSI-ORL-SQLPROD-CPA-CPA_Publication-BBA-BZN-POS01-87'
select  time, comments From msdistribution_agents
join MSdistribution_history on MSdistribution_history.agent_id=msdistribution_agents.id
where name=@distribution_agent_name
order by time DESC